<?php
$year = $route->restfulParams['year'];

$sql = "select *,sum(owr_salary+owr_post_salary+ou_workage_salary-ou_insurance_and_housing_fund+owr_commission-owr_duty_money) as salaryValue from art_organization_erp.art_oa_wage_record where owr_year_month like '%".$year."%' group by owr_year_month";

$rs = $db->mysqlDB->query($sql);

$response->responseData( true, $rs );